GetCells

Returns the ApiRange that represents all the cells on the worksheet (not just the cells that are currently in use).

Syntax

expression.GetCells(row, col);

expression - A variable that represents a ApiWorksheet class.

Name	Required/Optional	Data type	Default	Description
row	Required	number		The row number or the cell number (if only row is defined).
col	Required	number		The column number.

This example shows how to get the ApiRange that represents all the cells on the worksheet.

var oWorksheet = Api.GetActiveSheet();
var oCells = oWorksheet.GetCells();
oCells.SetFillColor(Api.CreateColorFromRGB(255, 213, 191));